This document outlines how to navigate and use features of the EFIS 2.0 File Download Portal.


The EFIS Download Portal is a repository of files which the ministry makes available to school boards on a regular basis. It contains files that were historically accessed through the Facilitating Documents folders in the ministry's EFIS 2.0 system. The portal also contains school boards' financial data, which was historically sent out via CD-ROM to its stakeholders. The portal includes data related to the four most recent years.


1 Logging In

In order to log into the EFIS File Download Portal, you must be registered for GO Secure; if you have not yet registered please follow the instructions in the Registration Guide. Once registered, visit the EFIS URL. The EFIS URL link will redirect to an OPS BPS Secure login page. Login with your email and password. If you have a PKI certificate instead, click Login with your certificate.

Login page

Once you sign in, you'll be sent to the EFIS homepage. Click on File Download Portal.

EFIS homepage

You'll be sent to the FDP (File Download Portal) homepage.

FDP homepage

2 File Organization and Navigation

There are two ways for a user to view the files that they have access to in the portal. On top of the files being organized in these ways, the user has the ability to search, filter and sort the results they see on each of the screen. The details of these features are described in the following sections.

2.1 Tree View Tab

The Tree View, which is the default tab of the portal, is where the files that the user has access to are organized in a hierarchical folder view.

Tree view tab

In order to access the needed files, the user must navigate through the different folders. The navigation can be done by single clicking the little arrow to the left of each folder.

Tree view tab

Clicking the "Expand All" button will display all the different folders available, and "Collapse All" will collapse back to top level. The image on the left is the behaviour of the "Expand All" button, while the right is that of the "Collapse All" button.

Expand/collapse all demonstration

The files contained in the folders are only shown at the Recipient and Doc Set levels. The recipient refers to the District School Board (or collection of District School Boards) and the Doc Set (Document Set) refers to the combination of School Year and Cycle (e.g. 2024-25 Estimates). Please note: the stakeholder data is published together for all District School Boards and thus the only recipient available will be "A00001 - Stakeholder Materials".

The tree view can be sorted in two different ways: By Recipient (Recipient > School Year > Cycle) or by Doc Set (School Year > Cycle > Recipient).

Differences between varying tree views

Files available for download are only accessible at two levels of the tree view: Recipient and Doc Set. This means that in order to see the files available the user must navigate to the correct level. For example, if the user navigates to just 2024-2025, they will not see any files and will get a message stating "Files are only shown on Recipient and Doc Set levels".

User on wrong level, unable to view files.

In order to view files related to 2024-2025, the user must select the particular Doc Set they want to see (e.g. 2024-2025 Estimates), by selecting the lowest level folder (e.g. Estimates)

User viewing 2024-2025 estimates

If the user wishes to see all files related to a certain Recipient, they can click on the recipient name, and all the files related to that recipient regardless of Doc Set will be visible.

User selecting a recipient

Please refer to the section Searching, Filtering and Sorting Files for detailed information on how to narrow down the list of files and take advantage of other capabilities of the portal.

2.2 Files Tab

The "Files" tab shows all the files that the user has access to shown in a single table. By default, the portal shows a list of 100 files per page. If the collection contains more than 100 files, the user can navigate to the next screen by clicking on the arrow found at the bottom right corner of the page. Please refer to the section Searching, Filtering and Sorting Files for detailed information on how to narrow down the list of files and take advantage of other capabilities of the portal.

Files tab

2.3 File Information

Each file in the portal will have information attached to it in order to help users understand the content that the file contains. There are a number of fields in the portal that are used to hold this information.

Field Name Tree Files Description
File Type x x The type / extension of the file (i.e. .zip, .pdf, .docx, .xlsx)
Filename x x The name of the file (i.e. what will the file be named on your machine once downloaded - i.e. DATA_1516FIS_FR.zip)
Doc Set x x Document Set ID in the system which is the short form combination of Document Type, Year and Cycle that the document relates to - i.e. S1718EST is a School Board document for the 2017-18 Estimates cycle
English Description x x The description of the file in English
French Description x x The description of the file in French
Create Date x x The date the file was uploaded to the system
Update Date x x The last time the file was changed in the system (if this matches the Create Date, then there has been no changes to the file)
Reporting Year x The reporting year that this file is related to (i.e. 2017-18 means that the file relates to the 2017-18 school year)
DS. Cycle x The Doc Set cycle that this file relates to (i.e. Estimates)
DS. Type x The Doc Set type that this file relates to (in most cases District School Board)
Recipient x The name of the recipient the file relates to (i.e. the name of the school board). Since stakeholder files are for all school boards, the recipient for these will always be "Stakeholder Materials"
Recipient ID x The system ID of the recipient (i.e. B66141 or A00001)

3 Searching, Filtering and Sorting Files

When the user has navigated to any screen that shows a list of files, the user can utilize a number of different methods to get to the file they are looking for. This is especially useful when looking at the “Files” tab that may contain a large number of files.

3.1 Search

The search capabilities allow the user to narrow down the list of files by typing in a search string into the search bar and hitting “Enter” on the keyboard or clicking the “Go” button. The search is performed on the entered string and returns all files that contain that string in ANY of the fields.

Searching for 'revised' term

In other words, if a user wanted to narrow down a large number of files below to only show files relating to Revised Estimates cycles, they could search for the term "Revised". The screen above now shows the search term under the Search Bar (e.g. "Row text contains 'Revised'") and the screen shows all the files that have the word “Revised” in any of the fields.

If the user then wanted to further narrow down the search to show only files that are in English, they could type “English” into the search bar and search again. This narrows the list even further, and both the search terms are shown under the search bar. Every time a user runs the search another term is added to the list.

Searching for 'English' term

If the user wants to widen the search again, they can either uncheck the search terms or completely delete them. For example, if the user wants to see all English documents, all they would have to do is uncheck the box next to "Row text contains 'Revised'", or click the red "X" next to it to remove the search term. In the case below, the user has unchecked the box, and if need be could quickly filter by the term "Revised" once again, saving them the need to re-type the term in the search box.

Unchecking 'revised' term

3.2 Basic Filter

Similar to the search capabilities, the filter functionality allows the user to narrow down the list of files. However, while the search capability looks through all fields, the filter capability allows the user to be more specific by focusing on selected fields and narrowing down the terms. For example, if a user was to search for “Estimates” while looking at a list of all files, they would get files related to both Estimates and Revised Estimates cycles due to the fact that the word “Estimates” is part of both phrases.

Searching for 'estimates'

In order to make sure they are only getting files relating to the estimates cycle, the user would filter on the field "DS. Cycle" having the value of "Estimates". A quick way to filter is by selecting from a list of available items in the drop down of a field. In the example above the user would click on the field named "DS. Cycle" which would give them a list of items to choose from. This drop down list below contains all the unique values under that field that are currently in the portal.

Filtering DS Cycle field for 'estimates'

Once the user clicks "Estimates" the filter is applied and the list shows only files related to the "Estimates" cycle. Note the difference between the filter applied in the search - "Row text contains 'Estimates'" and the filter below "DS. Cycle = 'Estimates'".

Filtered DS Cycle field for 'estimates'

The user can further narrow down the list by applying additional filters. One of the very useful filters is the date filter. For example, if the user wants to see only the Estimates files that were uploaded in the past month, they can quickly filter on the "Create Date" column and select "Last Month" from the drop down list.

Filtering for files created in the last month'

3.3 Advanced Filter

The portal allows for more advanced filtering as well. The advanced filters can be applied by going to Actions > Filter

Advanced filtering option

This gives the user the ability to filter on any of the columns using more advanced techniques. One example is filtering for files that were uploaded during a certain time. For example, if the user wanted to see all files that were uploaded in January 2024, they could filter based on the Create Date between January 1st and January 31st 2024.

Advanced filtering for January 2024 docs

The expression would be shown under the search bar and the results filtered accordingly.

Filtered January 2024 docs

3.4 Sort

By default, the files are sorted by Create Date (newest files on top) with the newest 100 files being shown on the first page. An arrow next to the “Create Date” field shows that this is the field currently being sorted by, and the arrow pointing downwards means that it is sorting in a descending order (newest to oldest).

Default, sorting by descending create date

If the user wants to change the sort order, for example sort by "Create Date" ascending (oldest to newest), the user can click on the title of the field and click on the arrow pointing up. The screen now shows the files with the oldest files on top.

Default, sorting by ascending create date

To sort by another field, the user would simply click the title of the other field and click one of the two arrows from the popup.

Sorting by reporting year

In the example above, the sorting is now being done on the "Reporting Year" field descending, with the newest reporting year files shown at the top. The arrow has now moved from the "Create Date" field to the "Reporting Year" field to indicate this.

Sorting by descending reporting year

3.5 Rows per Page

By default the screen will show 100 rows (files) per page. This can be changed by going to Actions > Rows Per Page and selecting a different number.

Selecting number of rows per page

4 Downloading Files

Once the user has found the files that they want to download they can download it by simply clicking on the file name link, found in the "Filename" field. Please note that the portal only allows for the downloading of one file at a time. In general, if a dataset contains a large number of files (such as stakeholder data) the files will be packaged into a zip file (this is easy to tell by looking at the "File Type" field which will indicate ".zip"). In order to see how large a file is before downloading it, the user can hover their mouse over the file name. In the example below the file named "ENROLMENT_2024-25.zip" is 2MB in size.

Hovering file name for file size

As mentioned, clicking the file name link (e.g. ENROLMENT_2024-25.zip) will start the download process of the file. Depending on which browser the user is using as well as their browser settings they will have a slightly different experience. For example, in Microsoft Edge, downloading a file automatically opens up the download tab and saves the .zip to the "Downloads" folder on the user's computer.

Downloading file Downloaded file, saved in downloads folder

4.1 Opening Zip Files

As mentioned before, zip files are used to create collections of data into one single file. Computers using the Windows operating system should all have a build in utility to work with .zip files. The user can contact their IT department in the case that they are not using Windows or do not see a zip utility. In order to open files found within zip files, the user can simply double click on the Zip file in the place where it is downloaded, and copy the necessary files out. Another option is to right-click the Zip file and select "Extract All" (on Windows computers). This will create a new folder which contains all the contents of the Zip file.

Extracting a zip file

4.2 Actions > Download

Please note that clicking the "Actions" button and selecting "Download" will NOT download any files. This will only download the list of files that the screen is showing at that time.

Download button from actions navigation

Changelog

Version Date Changed by Description
1.0 February 2019 LFIB Create document
1.1 February 2019 LFIB Update after review
1.2 March 2019 LFIB Finalized version
1.3 February 2024 EFIS Team Updated screenshots
Have any questions? Contact us by email at efis.support@ontario.ca or leave a voicemail at 416-326-8307.